CREATE PROC [dbo].[LOGIN]
@USR_NAME VARCHAR(25)
AS
SELECT
ID,
FULL_NAME,
USR_NAME,
PASS, 
AD_FLG
FROM 
USR
WHERE
UPPER(USR_NAME) = UPPER(@USR_NAME)
AND ACTIVE = 'A'